CREATE VIEW [dbo].[vSoaPaymentMethod]
AS
SELECT 'BillMe' AS [PaymentMethodId], 'Bill Me' AS [Name], 'BillMe' as [PaymentType],
       0 AS [CSCRequired], 0 AS [IssueNumberRequired], 0 AS [IssueDateRequired], 'You will be billed for the balance due' AS [Message]
UNION ALL
SELECT CASH_ACCOUNT_CODE AS [PaymentMethodId],
       [DESCRIPTION] AS [Name],
       CASE WHEN [ACCOUNT_TYPE] = 0 THEN 'Cash'
            WHEN [ACCOUNT_TYPE] = 1 THEN 'CreditCard'
            WHEN [ACCOUNT_TYPE] = 2 THEN 'Other'
            WHEN [ACCOUNT_TYPE] = 3 THEN 'DebitCard'
            WHEN [ACCOUNT_TYPE] = 4 THEN 'Service'
            ELSE 'Cash'
       END AS [PaymentType],
       CAST ([CSC_REQUIRED_WEB] AS BIT) AS [CSCRequired],
       CAST ([ISSUE_NO_FLAG] AS BIT) AS [IssueNumberRequired],
       CAST ([ISSUE_DATE_FLAG] AS BIT) AS [IssueDateRequired],
       CASE WHEN [ACCOUNT_TYPE] = 0 THEN 'Cash'
            ELSE [DESCRIPTION]
       END AS [Message]
FROM [dbo].[Cash_Accounts]



GO